Profiling Report

Dataset statistics

Number of variables	8
Number of observations	10001358
Missing cells	52158
Missing cells (%)	0.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.1 GiB
Average record size in memory	119.2 B

Variable types

Numeric	7
Categorical	1

Alerts

`CNT_INSTALMENT` is highly overall correlated with `CNT_INSTALMENT_FUTURE`	High correlation
`CNT_INSTALMENT_FUTURE` is highly overall correlated with `CNT_INSTALMENT`	High correlation
`SK_DPD` is highly overall correlated with `SK_DPD_DEF`	High correlation
`SK_DPD_DEF` is highly overall correlated with `SK_DPD`	High correlation
`NAME_CONTRACT_STATUS` is highly imbalanced (85.0%)	Imbalance
`SK_DPD_DEF` is highly skewed (γ1 = 66.33990581)	Skewed
`CNT_INSTALMENT_FUTURE` has 1185960 (11.9%) zeros	Zeros
`SK_DPD` has 9706131 (97.0%) zeros	Zeros
`SK_DPD_DEF` has 9887389 (98.9%) zeros	Zeros

Reproduction

Analysis started	2025-02-02 10:18:20.110300
Analysis finished	2025-02-02 10:26:06.894337
Duration	7 minutes and 46.78 seconds
Software version	ydata-profiling vv4.12.2
Download configuration	config.json

SK_ID_PREV
Real number (ℝ)

Distinct	936325
Distinct (%)	9.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1903216.6

Minimum	1000001
Maximum	2843499
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	76.3 MiB

Quantile statistics

Minimum	1000001
5-th percentile	1083660
Q1	1434405
median	1896565
Q3	2368963
95-th percentile	2749774
Maximum	2843499
Range	1843498
Interquartile range (IQR)	934558

Descriptive statistics

Standard deviation	535846.53
Coefficient of variation (CV)	0.28154784
Kurtosis	-1.216184
Mean	1903216.6
Median Absolute Deviation (MAD)	466541
Skewness	0.044229231
Sum	1.9034751 × 10¹³
Variance	2.871315 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1856103	96	< 0.1%
2706683	96	< 0.1%
1617536	96	< 0.1%
1364606	96	< 0.1%
1057553	96	< 0.1%
2764503	96	< 0.1%
1271619	96	< 0.1%
1326802	96	< 0.1%
2181136	96	< 0.1%
1276472	96	< 0.1%
Other values (936315)	10000398	> 99.9%

Value	Count	Frequency (%)
1000001	3	< 0.1%
1000002	5	< 0.1%
1000003	4	< 0.1%
1000004	8	< 0.1%
1000005	11	< 0.1%
1000007	5	< 0.1%
1000008	10	< 0.1%
1000009	7	< 0.1%
1000010	11	< 0.1%
1000011	13	< 0.1%

Value	Count	Frequency (%)
2843499	11	< 0.1%
2843498	7	< 0.1%
2843497	21	< 0.1%
2843495	8	< 0.1%
2843494	3	< 0.1%
2843492	13	< 0.1%
2843491	10	< 0.1%
2843490	7	< 0.1%
2843489	25	< 0.1%
2843488	11	< 0.1%

SK_ID_CURR
Real number (ℝ)

Distinct	337252
Distinct (%)	3.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	278403.86

Minimum	100001
Maximum	456255
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	76.3 MiB

Quantile statistics

Minimum	100001
5-th percentile	117988
Q1	189550
median	278654
Q3	367429
95-th percentile	438533
Maximum	456255
Range	356254
Interquartile range (IQR)	177879

Descriptive statistics

Standard deviation	102763.75
Coefficient of variation (CV)	0.36911753
Kurtosis	-1.1968387
Mean	278403.86
Median Absolute Deviation (MAD)	88944
Skewness	-0.0031282533
Sum	2.7844167 × 10¹²
Variance	1.0560387 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
265042	295	< 0.1%
172612	247	< 0.1%
309133	246	< 0.1%
127659	245	< 0.1%
185185	245	< 0.1%
197583	245	< 0.1%
203046	244	< 0.1%
362661	239	< 0.1%
398407	237	< 0.1%
228307	235	< 0.1%
Other values (337242)	9998880	> 99.9%

Value	Count	Frequency (%)
100001	9	< 0.1%
100002	19	< 0.1%
100003	28	< 0.1%
100004	4	< 0.1%
100005	11	< 0.1%
100006	21	< 0.1%
100007	66	< 0.1%
100008	83	< 0.1%
100009	64	< 0.1%
100010	11	< 0.1%

Value	Count	Frequency (%)
456255	71	< 0.1%
456254	20	< 0.1%
456253	17	< 0.1%
456252	7	< 0.1%
456251	9	< 0.1%
456250	30	< 0.1%
456249	13	< 0.1%
456248	43	< 0.1%
456247	27	< 0.1%
456246	7	< 0.1%

MONTHS_BALANCE
Real number (ℝ)

Distinct	96
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-35.012588

Minimum	-96
Maximum	-1
Zeros	0
Zeros (%)	0.0%
Negative	10001358
Negative (%)	100.0%
Memory size	76.3 MiB

Quantile statistics

Minimum	-96
5-th percentile	-85
Q1	-54
median	-28
Q3	-13
95-th percentile	-4
Maximum	-1
Range	95
Interquartile range (IQR)	41

Descriptive statistics

Standard deviation	26.06657
Coefficient of variation (CV)	-0.74449138
Kurtosis	-0.71068083
Mean	-35.012588
Median Absolute Deviation (MAD)	18
Skewness	-0.67277715
Sum	-3.5017343 × 10⁸
Variance	679.46607
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-10	216441	2.2%
-11	216023	2.2%
-9	215558	2.2%
-12	214716	2.1%
-8	214149	2.1%
-13	210950	2.1%
-7	210229	2.1%
-14	208352	2.1%
-6	206849	2.1%
-15	204935	2.0%
Other values (86)	7883156	78.8%

Value	Count	Frequency (%)
-96	36448	0.4%
-95	38514	0.4%
-94	39900	0.4%
-93	41025	0.4%
-92	42283	0.4%
-91	43652	0.4%
-90	45295	0.5%
-89	47763	0.5%
-88	49950	0.5%
-87	51805	0.5%

Value	Count	Frequency (%)
-1	94908	0.9%
-2	169529	1.7%
-3	183589	1.8%
-4	193147	1.9%
-5	200726	2.0%
-6	206849	2.1%
-7	210229	2.1%
-8	214149	2.1%
-9	215558	2.2%
-10	216441	2.2%

CNT_INSTALMENT
Real number (ℝ)

High correlation

Distinct	73
Distinct (%)	< 0.1%
Missing	26071
Missing (%)	0.3%
Infinite	0
Infinite (%)	0.0%
Mean	17.08965

Minimum	1
Maximum	92
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	76.3 MiB

Quantile statistics

Minimum	1
5-th percentile	6
Q1	10
median	12
Q3	24
95-th percentile	45
Maximum	92
Range	91
Interquartile range (IQR)	14

Descriptive statistics

Standard deviation	11.995056
Coefficient of variation (CV)	0.70189007
Kurtosis	2.4468723
Mean	17.08965
Median Absolute Deviation (MAD)	6
Skewness	1.6017338
Sum	1.7047417 × 10⁸
Variance	143.88137
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
12	2496845	25.0%
24	1517472	15.2%
10	1243449	12.4%
6	1065500	10.7%
18	727394	7.3%
36	584574	5.8%
8	303751	3.0%
48	278513	2.8%
4	238223	2.4%
30	211920	2.1%
Other values (63)	1307646	13.1%

Value	Count	Frequency (%)
1	24544	0.2%
2	26826	0.3%
3	43081	0.4%
4	238223	2.4%
5	136840	1.4%
6	1065500	10.7%
7	106714	1.1%
8	303751	3.0%
9	148355	1.5%
10	1243449	12.4%

Value	Count	Frequency (%)
92	1	< 0.1%
84	5	< 0.1%
81	1	< 0.1%
77	4	< 0.1%
72	1519	< 0.1%
71	3	< 0.1%
70	2	< 0.1%
68	1	< 0.1%
66	108	< 0.1%
64	3	< 0.1%

CNT_INSTALMENT_FUTURE
Real number (ℝ)

High correlation Zeros

Distinct	79
Distinct (%)	< 0.1%
Missing	26087
Missing (%)	0.3%
Infinite	0
Infinite (%)	0.0%
Mean	10.48384

Minimum	0
Maximum	85
Zeros	1185960
Zeros (%)	11.9%
Negative	0
Negative (%)	0.0%
Memory size	76.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	3
median	7
Q3	14
95-th percentile	35
Maximum	85
Range	85
Interquartile range (IQR)	11

Descriptive statistics

Standard deviation	11.109058
Coefficient of variation (CV)	1.0596363
Kurtosis	3.7133282
Mean	10.48384
Median Absolute Deviation (MAD)	5
Skewness	1.8467459
Sum	1.0457915 × 10⁸
Variance	123.41116
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1185960	11.9%
6	614058	6.1%
4	613632	6.1%
5	600295	6.0%
3	582007	5.8%
2	547199	5.5%
1	512279	5.1%
10	481390	4.8%
8	480167	4.8%
7	472665	4.7%
Other values (69)	3885619	38.9%

Value	Count	Frequency (%)
0	1185960	11.9%
1	512279	5.1%
2	547199	5.5%
3	582007	5.8%
4	613632	6.1%
5	600295	6.0%
6	614058	6.1%
7	472665	4.7%
8	480167	4.8%
9	467606	4.7%

Value	Count	Frequency (%)
85	1	< 0.1%
84	1	< 0.1%
83	1	< 0.1%
82	1	< 0.1%
81	1	< 0.1%
80	1	< 0.1%
72	35	< 0.1%
71	33	< 0.1%
70	32	< 0.1%
69	32	< 0.1%

NAME_CONTRACT_STATUS
Categorical

Imbalance

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	603.1 MiB

Active	9151119
Completed	744883
Signed	87260
Demand	7065
Returned to the store	5461
Other values (4)	5570

Length

Max length	21
Median length	6
Mean length	6.2331193
Min length	3

Characters and Unicode

Total characters	62339658
Distinct characters	27
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Active
2nd row	Active
3rd row	Active
4th row	Active
5th row	Active

Common Values

Value	Count	Frequency (%)
Active	9151119	91.5%
Completed	744883	7.4%
Signed	87260	0.9%
Demand	7065	0.1%
Returned to the store	5461	0.1%
Approved	4917	< 0.1%
Amortized debt	636	< 0.1%
Canceled	15	< 0.1%
XNA	2	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
active	9151119	91.3%
completed	744883	7.4%
signed	87260	0.9%
demand	7065	0.1%
returned	5461	0.1%
to	5461	0.1%
the	5461	0.1%
store	5461	0.1%
approved	4917	< 0.1%
amortized	636	< 0.1%
Other values (3)	653	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
e	10763273	17.3%
t	9919118	15.9%
i	9239015	14.8%
A	9156674	14.7%
v	9156036	14.7%
c	9151134	14.7%
d	850873	1.4%
o	761358	1.2%
p	754717	1.2%
m	752584	1.2%
Other values (17)	1834876	2.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	62339658	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	10763273	17.3%
t	9919118	15.9%
i	9239015	14.8%
A	9156674	14.7%
v	9156036	14.7%
c	9151134	14.7%
d	850873	1.4%
o	761358	1.2%
p	754717	1.2%
m	752584	1.2%
Other values (17)	1834876	2.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	62339658	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	10763273	17.3%
t	9919118	15.9%
i	9239015	14.8%
A	9156674	14.7%
v	9156036	14.7%
c	9151134	14.7%
d	850873	1.4%
o	761358	1.2%
p	754717	1.2%
m	752584	1.2%
Other values (17)	1834876	2.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	62339658	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	10763273	17.3%
t	9919118	15.9%
i	9239015	14.8%
A	9156674	14.7%
v	9156036	14.7%
c	9151134	14.7%
d	850873	1.4%
o	761358	1.2%
p	754717	1.2%
m	752584	1.2%
Other values (17)	1834876	2.9%

SK_DPD
Real number (ℝ)

High correlation Zeros

Distinct	3400
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11.606928

Minimum	0
Maximum	4231
Zeros	9706131
Zeros (%)	97.0%
Negative	0
Negative (%)	0.0%
Memory size	76.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	4231
Range	4231
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	132.71404
Coefficient of variation (CV)	11.434037
Kurtosis	255.3222
Mean	11.606928
Median Absolute Deviation (MAD)	0
Skewness	14.899126
Sum	1.1608504 × 10⁸
Variance	17613.017
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	9706131	97.0%
1	21872	0.2%
2	17358	0.2%
3	14403	0.1%
4	12350	0.1%
5	11046	0.1%
6	9615	0.1%
7	8332	0.1%
8	7360	0.1%
9	6668	0.1%
Other values (3390)	186223	1.9%

Value	Count	Frequency (%)
0	9706131	97.0%
1	21872	0.2%
2	17358	0.2%
3	14403	0.1%
4	12350	0.1%
5	11046	0.1%
6	9615	0.1%
7	8332	0.1%
8	7360	0.1%
9	6668	0.1%

Value	Count	Frequency (%)
4231	1	< 0.1%
4200	1	< 0.1%
4172	1	< 0.1%
4141	1	< 0.1%
4110	1	< 0.1%
4108	1	< 0.1%
4080	1	< 0.1%
4078	1	< 0.1%
4050	2	< 0.1%
4049	1	< 0.1%

SK_DPD_DEF
Real number (ℝ)

High correlation Skewed Zeros

Distinct	2307
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.65446842

Minimum	0
Maximum	3595
Zeros	9887389
Zeros (%)	98.9%
Negative	0
Negative (%)	0.0%
Memory size	76.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	3595
Range	3595
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	32.762491
Coefficient of variation (CV)	50.059696
Kurtosis	4836.5494
Mean	0.65446842
Median Absolute Deviation (MAD)	0
Skewness	66.339906
Sum	6545573
Variance	1073.3808
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	9887389	98.9%
1	22134	0.2%
2	14690	0.1%
3	11652	0.1%
4	9528	0.1%
5	8031	0.1%
6	6629	0.1%
7	5425	0.1%
8	4538	< 0.1%
9	3935	< 0.1%
Other values (2297)	27407	0.3%

Value	Count	Frequency (%)
0	9887389	98.9%
1	22134	0.2%
2	14690	0.1%
3	11652	0.1%
4	9528	0.1%
5	8031	0.1%
6	6629	0.1%
7	5425	0.1%
8	4538	< 0.1%
9	3935	< 0.1%

Value	Count	Frequency (%)
3595	1	< 0.1%
3565	1	< 0.1%
3534	1	< 0.1%
3506	1	< 0.1%
3475	1	< 0.1%
3468	1	< 0.1%
3444	1	< 0.1%
3438	1	< 0.1%
3414	1	< 0.1%
3407	1	< 0.1%

	CNT_INSTALMENT	CNT_INSTALMENT_FUTURE	MONTHS_BALANCE	NAME_CONTRACT_STATUS	SK_DPD	SK_DPD_DEF	SK_ID_CURR	SK_ID_PREV
CNT_INSTALMENT	1.000	0.741	0.348	0.081	-0.075	0.006	0.000	0.003
CNT_INSTALMENT_FUTURE	0.741	1.000	0.249	0.098	-0.150	-0.032	-0.001	0.003
MONTHS_BALANCE	0.348	0.249	1.000	0.022	-0.105	-0.038	0.000	0.002
NAME_CONTRACT_STATUS	0.081	0.098	0.022	1.000	0.075	0.228	0.003	0.004
SK_DPD	-0.075	-0.150	-0.105	0.075	1.000	0.606	0.002	0.000
SK_DPD_DEF	0.006	-0.032	-0.038	0.228	0.606	1.000	0.000	0.001
SK_ID_CURR	0.000	-0.001	0.000	0.003	0.002	0.000	1.000	-0.000
SK_ID_PREV	0.003	0.003	0.002	0.004	0.000	0.001	-0.000	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

	SK_ID_PREV	SK_ID_CURR	MONTHS_BALANCE	CNT_INSTALMENT	CNT_INSTALMENT_FUTURE	NAME_CONTRACT_STATUS
0	1803195	182943	-31	48.0	45.0	Active
1	1715348	367990	-33	36.0	35.0	Active
2	1784872	397406	-32	12.0	9.0	Active
3	1903291	269225	-35	48.0	42.0	Active
4	2341044	334279	-35	36.0	35.0	Active
5	2207092	342166	-32	12.0	12.0	Active
6	1110516	204376	-38	48.0	43.0	Active
7	1387235	153211	-35	36.0	36.0	Active
8	1220500	112740	-31	12.0	12.0	Active
9	2371489	274851	-32	24.0	16.0	Active

	SK_ID_PREV	SK_ID_CURR	MONTHS_BALANCE	CNT_INSTALMENT	NAME_CONTRACT_STATUS	SK_DPD
10001348	2234984	191559	-22	6.0	Active	797
10001349	2340692	104125	-24	6.0	Active	944
10001350	2593362	198894	-20	12.0	Completed	0
10001351	2639809	288279	-25	6.0	Active	925
10001352	2700641	448867	-19	6.0	Active	843
10001353	2448283	226558	-20	6.0	Active	843
10001354	1717234	141565	-19	12.0	Active	602
10001355	1283126	315695	-21	10.0	Active	609
10001356	1082516	450255	-22	12.0	Active	614
10001357	1259607	174278	-52	16.0	Completed	0

Overview

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample